IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[UpdateLinea]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
	DROP PROCEDURE [dbo].[UpdateLinea]
GO

CREATE PROCEDURE [dbo].[UpdateLinea]
(
	@IdLinea int,
	@Nombre varchar(255),
	@Descripcion text,
	@Imagen varchar(150)
)
AS
BEGIN
	SET NOCOUNT ON

	UPDATE [Linea]
	SET [Nombre] = @Nombre, 
		[Descripcion] = @Descripcion, 
		[Imagen] = @Imagen
	WHERE [IdLinea] = @IdLinea

	SET NOCOUNT OFF
END

GO
